import xlrd

work_book = xlrd.open_workbook('test.xls')
sheet = work_book.sheet_by_name("work")
# 获取行数、列数
print(sheet.nrows)
print(sheet.ncols)
# 打印指定行
print(sheet.row_values(0))
print(sheet.row_values(2))
# 打印指定列
print(sheet.col_values(0))
print(sheet.col_values(1))
# 打印指定的单元格
print(sheet.cell_value(0,0))
print(sheet.cell_value(1,1))